BusinessUnitGroupLevel

Entity Definition

Logical Name : BusinessUnitGroupLevel
Physical Name : CO_BSNGP_LV

A grouping level for sets of BusinessUnits such as District, Group, Cluster, Region, State, Territory, Country, Zone etc...

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupFunctionID (FK) A unique system assigned identifier for a BusinessUnit hierarchy business function. ID_BSNGP_FNC Identity integer BusinessUnitGroupLevel(CO_BSNGP_LV)
BusinessUnitGroupFunctionID (FK)(PK) A unique system assigned identifier for a BusinessUnit hierarchy business function. ID_BSNGP_FNC Identity integer BusinessUnitGroupFunction(CO_BSNGP_FNC)
BusinessUnitGroupLevelID (PK) A unique system assigned identifier for a level within the BusinessUnit grouping hierarchy. ID_BSNGP_LV Identity integer
BusinessUnitCenterGroupLevelID (FK) A unique system assigned identifier for a level within the BusinessUnit grouping hierarchy. ID_BSNGP_LV_PRNT Identity integer BusinessUnitGroupLevel(CO_BSNGP_LV)
BusinessUnitGroupLevelName The common name of a level within the BusinessUnit grouping hierarchy. NM_BSNGP_LV Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
BusinessUnitGroupFunction defines BusinessUnitGroupLevel
BusinessUnitGroupLevel has parent BusinessUnitGroupLevel
BusinessUnitGroupLevel defines parent AssociatedBusinessUnitGroup
BusinessUnitGroupLevel has parent BusinessUnitGroupLevel

Logical Views containing BusinessUnitGroupLevel

Logical View
Logical 01020 - Item Description - Enterprise View
Logical 03200 - Reporting - Item Sales View
Logical 03300 - Reporting - Stock Ledger View
Logical 06100 - Calendar View
Logical 10102 - EnterpriseWeather
Logical 10110 - Enterprise - Location Retailer Organization View
Logical 10115 - Enterprise - Business Unit Groups Hierarchy View
Logical 10200 - Enterprise - Merchandise View
Logical 10400 - Enterprise - Channels